Mysql connections not released

------=_NextPart_000_0083_01CB19C4.CBC179D0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0084_01CB19C4.CBC179D0"


------=_NextPart_001_0084_01CB19C4.CBC179D0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Good morning all



A few days ago i posted some questions relating to mysql
threads running out and not being able to restart the database.



We had the same again this morning however this time I had a
bit of a heads up and managed to get into the database before it went down
(so to speak).





What I found was the following:



.. When running ' show processlist', the amount of processes were
increasing the whole time.

.. From the details, it seemed that all the connections were coming
from the website and were trying to make connections to the database,
however the statuses never changed from connect to anything else, and yet
the amount of connections kept on rising.

.. From what I could gather, the incoming processes were trying to
connect to the database but the connections could not be released causing
havoc.



I have tried to find clues in log files, etc... but nothing turned up. I
suspected that it could perhaps be php however this could not be verified
yet.



Can someone please provide me with some thoughts as to why this could be
happening? I am fairly new to MySQL and not sure where else to go from here
to find the root cause.



Generally everything works fine, however , every now and then things
suddenly seem to be going wrong... L



Any help would be appreciated.



Machiel Richards

MySQL DBA

Relational Database Consulting



RDC_Logo




------=_NextPart_001_0084_01CB19C4.CBC179D0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

Re: Mysql connections not released

--0016364edd6adef67e048a62ba66
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards wrote=
:

> Good morning all
>
>
>
> A few days ago i posted some questions relating to mysql
> threads running out and not being able to restart the database.
>
>
>
> We had the same again this morning however this time I ha=
d
> a bit of a heads up and managed to get into the database before it went d=
own
> (so to speak).
>
>
>
>
>
> What I found was the following:
>
>
>
> =B7 When running =91 show processlist=92, the amount of processes=
were
> increasing the whole time.
>
> =B7 From the details, it seemed that all the connections were com=
ing
> from the website and were trying to make connections to the database,
> however the statuses never changed from connect to anything else, and yet
> the amount of connections kept on rising.
>
> =B7 From what I could gather, the incoming processes were trying =
to
> connect to the database but the connections could not be released causing
> havoc.
>
>
>
> I have tried to find clues in log files, etc... but nothing turned up. I
> suspected that it could perhaps be php however this could not be verified
> yet.
>
>
>
> Can someone please provide me with some thoughts as to why this could be
> happening? I am fairly new to MySQL and not sure where else to go from he=
re
> to find the root cause.
>
>
>
> Generally everything works fine, however , every now and then things
> suddenly seem to be going wrong... L
>
>
>
> Any help would be appreciated.
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: RDC_Logo]
>
>
>
My first guess would be a networking problem. If you run ifconfig repeatedl=
y
do you notice the number of errors increasing? It would be good to look at
both the database server and the web server. Also, until you figure the
issue out you should be able to mitigate it by setting the connect timeout
to a more aggressive value.


--=20
Rob Wultsch
wultsch@gmail.com

--0016364edd6adef67e048a62ba66--

RE: Mysql connections not released

------=_NextPart_000_00D5_01CB19CE.1BA581E0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_00D6_01CB19CE.1BA581E0"


------=_NextPart_001_00D6_01CB19CE.1BA581E0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi



From a thread found on the net it also suggests that it might be network
or DNS related.



The connections building up is the following:



*************************** 1346. row
***************************

Id: 903175

User: unauthenticated user

Host: :51798

db: NULL

Command: Connect

Time: NULL

State: login

Info: NULL





The servers however only uses ip connections and no DNS
related lookups.



From what I could find on the web though it seems that there
is one session that is unable to authenticate and the authentication process
does not complete causing it to get "stuck"

This then causes all other requests to wait for the
transaction to complete.



Everyone who replied to these threads with the same issue
stated that when they kill that one problem connection it brings everything
back to normal again, however the problem happens regularly and if not
picked up immediately eventually causes an inability to access the database
to even kill processes, etc...





So what I know now is that the problem is caused by a
connection / transaction not completing. However what I need to find out now
is why and how to resolve this.







Machiel Richards

MySQL DBA

Relational Database Consulting



RDC_Logo



From: Rob Wultsch [mailto:wultsch@gmail.com]
Sent: 02 July 2010 9:42 AM
To: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: Mysql connections not released



On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards
wrote:

Good morning all



A few days ago i posted some questions relating to mysql
threads running out and not being able to restart the database.



We had the same again this morning however this time I had a
bit of a heads up and managed to get into the database before it went down
(so to speak).





What I found was the following:



.. When running ' show processlist', the amount of processes were
increasing the whole time.

.. From the details, it seemed that all the connections were coming
from the website and were trying to make connections to the database,
however the statuses never changed from connect to anything else, and yet
the amount of connections kept on rising.

.. From what I could gather, the incoming processes were trying to
connect to the database but the connections could not be released causing
havoc.



I have tried to find clues in log files, etc... but nothing turned up. I
suspected that it could perhaps be php however this could not be verified
yet.



Can someone please provide me with some thoughts as to why this could be
happening? I am fairly new to MySQL and not sure where else to go from here
to find the root cause.



Generally everything works fine, however , every now and then things
suddenly seem to be going wrong... L



Any help would be appreciated.



Machiel Richards

MySQL DBA

Relational Database Consulting



Error! Filename not specified.



My first guess would be a networking problem. If you run ifconfig repeatedly
do you notice the number of errors increasing? It would be good to look at
both the database server and the web server. Also, until you figure the
issue out you should be able to mitigate it by setting the connect timeout
to a more aggressive value.


--
Rob Wultsch
wultsch@gmail.com


------=_NextPart_001_00D6_01CB19CE.1BA581E0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

Re: Mysql connections not released

--00c09fa21cb40bbd6a048a639eae
Content-Type: multipart/alternative; boundary=00c09fa21cb40bbd64048a639ead

--00c09fa21cb40bbd64048a639ead
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

A bad assumption I make these days is that everyone has skip resolve off. I=
f
that is the case DNS issues will not impact you.

Do you have that setting?
Do you see errors on the interface?

On Fri, Jul 2, 2010 at 1:05 AM, Machiel Richards wrote=
:

> Hi
>
>
>
> From a thread found on the net it also suggests that it might be netwo=
rk
> or DNS related.
>
>
>
> The connections building up is the following:
>
>
>
> *************************** 1346. row
> ***************************
>
> Id: 903175
>
> User: unauthenticated user
>
> Host: :51798
>
> db: NULL
>
> Command: Connect
>
> Time: NULL
>
> State: login
>
> Info: NULL
>
>
>
>
>
> The servers however only uses ip connections and no DNS
> related lookups.
>
>
>
> From what I could find on the web though it seems that
> there is one session that is unable to authenticate and the authenticatio=
n
> process does not complete causing it to get =93stuck=94
>
> This then causes all other requests to wait for the
> transaction to complete.
>
>
>
> Everyone who replied to these threads with the same issue
> stated that when they kill that one problem connection it brings everythi=
ng
> back to normal again, however the problem happens regularly and if not
> picked up immediately eventually causes an inability to access the databa=
se
> to even kill processes, etc...
>
>
>
>
>
> So what I know now is that the problem is caused by a
> connection / transaction not completing. However what I need to find out =
now
> is why and how to resolve this.
>
>
>
>
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: RDC_Logo]
>
>
>
> *From:* Rob Wultsch [mailto:wultsch@gmail.com]
> *Sent:* 02 July 2010 9:42 AM
> *To:* Machiel Richards
> *Cc:* mysql@lists.mysql.com
> *Subject:* Re: Mysql connections not released
>
>
>
> On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards
> wrote:
>
> Good morning all
>
>
>
> A few days ago i posted some questions relating to mysql
> threads running out and not being able to restart the database.
>
>
>
> We had the same again this morning however this time I ha=
d
> a bit of a heads up and managed to get into the database before it went d=
own
> (so to speak).
>
>
>
>
>
> What I found was the following:
>
>
>
> =B7 When running =91 show processlist=92, the amount of processes=
were
> increasing the whole time.
>
> =B7 From the details, it seemed that all the connections were com=
ing
> from the website and were trying to make connections to the database,
> however the statuses never changed from connect to anything else, and yet
> the amount of connections kept on rising.
>
> =B7 From what I could gather, the incoming processes were trying =
to
> connect to the database but the connections could not be released causing
> havoc.
>
>
>
> I have tried to find clues in log files, etc... but nothing turned up. I
> suspected that it could perhaps be php however this could not be verified
> yet.
>
>
>
> Can someone please provide me with some thoughts as to why this could be
> happening? I am fairly new to MySQL and not sure where else to go from he=
re
> to find the root cause.
>
>
>
> Generally everything works fine, however , every now and then things
> suddenly seem to be going wrong... L
>
>
>
> Any help would be appreciated.
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> *Error! Filename not specified.*
>
>
>
> My first guess would be a networking problem. If you run ifconfig
> repeatedly do you notice the number of errors increasing? It would be goo=
d
> to look at both the database server and the web server. Also, until you
> figure the issue out you should be able to mitigate it by setting the
> connect timeout to a more aggressive value.
>
>
> --
> Rob Wultsch
> wultsch@gmail.com
>



--=20
Rob Wultsch
wultsch@gmail.com

--00c09fa21cb40bbd64048a639ead
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

A bad assumption I make these days is that everyone has skip resolve off. I=
f that is the case DNS issues will not impact you.

Do you have that =
setting?
Do you see errors on the interface?

RE: Mysql connections not released

------=_NextPart_000_0122_01CB19D4.298B3060
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0123_01CB19D4.298B3060"


------=_NextPart_001_0123_01CB19D4.298B3060
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

We do not use that setting at present no.... specifically because all hosts
use ip's to connect and not dns / hostnames.



We can't seem to find any errors thus the reason for truggling to pinpoint
the exact cause.



Machiel Richards

MySQL DBA

Relational Database Consulting



RDC_Logo



From: Rob Wultsch [mailto:wultsch@gmail.com]
Sent: 02 July 2010 10:46 AM
To: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: Mysql connections not released



A bad assumption I make these days is that everyone has skip resolve off. If
that is the case DNS issues will not impact you.

Do you have that setting?
Do you see errors on the interface?

On Fri, Jul 2, 2010 at 1:05 AM, Machiel Richards wrote:

Hi



From a thread found on the net it also suggests that it might be network
or DNS related.



The connections building up is the following:



*************************** 1346. row
***************************

Id: 903175

User: unauthenticated user

Host: :51798

db: NULL

Command: Connect

Time: NULL

State: login

Info: NULL





The servers however only uses ip connections and no DNS
related lookups.



From what I could find on the web though it seems that there
is one session that is unable to authenticate and the authentication process
does not complete causing it to get "stuck"

This then causes all other requests to wait for the
transaction to complete.



Everyone who replied to these threads with the same issue
stated that when they kill that one problem connection it brings everything
back to normal again, however the problem happens regularly and if not
picked up immediately eventually causes an inability to access the database
to even kill processes, etc...





So what I know now is that the problem is caused by a
connection / transaction not completing. However what I need to find out now
is why and how to resolve this.







Machiel Richards

MySQL DBA

Relational Database Consulting



RDC_Logo



From: Rob Wultsch [mailto:wultsch@gmail.com]
Sent: 02 July 2010 9:42 AM
To: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: Mysql connections not released



On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards
wrote:

Good morning all



A few days ago i posted some questions relating to mysql
threads running out and not being able to restart the database.



We had the same again this morning however this time I had a
bit of a heads up and managed to get into the database before it went down
(so to speak).





What I found was the following:



.. When running ' show processlist', the amount of processes were
increasing the whole time.

.. From the details, it seemed that all the connections were coming
from the website and were trying to make connections to the database,
however the statuses never changed from connect to anything else, and yet
the amount of connections kept on rising.

.. From what I could gather, the incoming processes were trying to
connect to the database but the connections could not be released causing
havoc.



I have tried to find clues in log files, etc... but nothing turned up. I
suspected that it could perhaps be php however this could not be verified
yet.



Can someone please provide me with some thoughts as to why this could be
happening? I am fairly new to MySQL and not sure where else to go from here
to find the root cause.



Generally everything works fine, however , every now and then things
suddenly seem to be going wrong... L



Any help would be appreciated.



Machiel Richards

MySQL DBA

Relational Database Consulting



Error! Filename not specified.



My first guess would be a networking problem. If you run ifconfig repeatedly
do you notice the number of errors increasing? It would be good to look at
both the database server and the web server. Also, until you figure the
issue out you should be able to mitigate it by setting the connect timeout
to a more aggressive value.


--
Rob Wultsch
wultsch@gmail.com




--
Rob Wultsch
wultsch@gmail.com


------=_NextPart_001_0123_01CB19D4.298B3060
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/mee tings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/x ml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di rectory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/20 02/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/partto part" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/wor kflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsi g-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsi g" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/200 6/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compa tibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006/types"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor talServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"
" xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

Re: Mysql connections not released

--001636164ab56e975d048a63cbd4
Content-Type: multipart/alternative; boundary=001636164ab56e9756048a63cbd3

--001636164ab56e9756048a63cbd3
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

I do not know that part of the mysql source code well, but I am very sure
you will take the dns hit even if all of your grants are ip based.

I suggest you put put that setting into your cnf and bounce the instance.

You will also never run into issues with max connect error if you set skip
name resolve.

It might be worthwhile to start watching a continuous ping from the
webserver to the db server. Are you losing any packets?

On Fri, Jul 2, 2010 at 1:48 AM, Machiel Richards wrote=
:

> We do not use that setting at present no.... specifically because all
> hosts use ip=92s to connect and not dns / hostnames.
>
>
>
> We can=92t seem to find any errors thus the reason for truggling to pinpo=
int
> the exact cause.
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: RDC_Logo]
>
>
>
> *From:* Rob Wultsch [mailto:wultsch@gmail.com]
> *Sent:* 02 July 2010 10:46 AM
>
> *To:* Machiel Richards
> *Cc:* mysql@lists.mysql.com
> *Subject:* Re: Mysql connections not released
>
>
>
> A bad assumption I make these days is that everyone has skip resolve off.
> If that is the case DNS issues will not impact you.
>
> Do you have that setting?
> Do you see errors on the interface?
>
> On Fri, Jul 2, 2010 at 1:05 AM, Machiel Richards
> wrote:
>
> Hi
>
>
>
> From a thread found on the net it also suggests that it might be netwo=
rk
> or DNS related.
>
>
>
> The connections building up is the following:
>
>
>
> *************************** 1346. row
> ***************************
>
> Id: 903175
>
> User: unauthenticated user
>
> Host: :51798
>
> db: NULL
>
> Command: Connect
>
> Time: NULL
>
> State: login
>
> Info: NULL
>
>
>
>
>
> The servers however only uses ip connections and no DNS
> related lookups.
>
>
>
> From what I could find on the web though it seems that
> there is one session that is unable to authenticate and the authenticatio=
n
> process does not complete causing it to get =93stuck=94
>
> This then causes all other requests to wait for the
> transaction to complete.
>
>
>
> Everyone who replied to these threads with the same issue
> stated that when they kill that one problem connection it brings everythi=
ng
> back to normal again, however the problem happens regularly and if not
> picked up immediately eventually causes an inability to access the databa=
se
> to even kill processes, etc...
>
>
>
>
>
> So what I know now is that the problem is caused by a
> connection / transaction not completing. However what I need to find out =
now
> is why and how to resolve this.
>
>
>
>
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: RDC_Logo]
>
>
>
> *From:* Rob Wultsch [mailto:wultsch@gmail.com]
> *Sent:* 02 July 2010 9:42 AM
> *To:* Machiel Richards
> *Cc:* mysql@lists.mysql.com
> *Subject:* Re: Mysql connections not released
>
>
>
> On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards
> wrote:
>
> Good morning all
>
>
>
> A few days ago i posted some questions relating to mysql
> threads running out and not being able to restart the database.
>
>
>
> We had the same again this morning however this time I ha=
d
> a bit of a heads up and managed to get into the database before it went d=
own
> (so to speak).
>
>
>
>
>
> What I found was the following:
>
>
>
> =B7 When running =91 show processlist=92, the amount of processes=
were
> increasing the whole time.
>
> =B7 From the details, it seemed that all the connections were com=
ing
> from the website and were trying to make connections to the database,
> however the statuses never changed from connect to anything else, and yet
> the amount of connections kept on rising.
>
> =B7 From what I could gather, the incoming processes were trying =
to
> connect to the database but the connections could not be released causing
> havoc.
>
>
>
> I have tried to find clues in log files, etc... but nothing turned up. I
> suspected that it could perhaps be php however this could not be verified
> yet.
>
>
>
> Can someone please provide me with some thoughts as to why this could be
> happening? I am fairly new to MySQL and not sure where else to go from he=
re
> to find the root cause.
>
>
>
> Generally everything works fine, however , every now and then things
> suddenly seem to be going wrong... L
>
>
>
> Any help would be appreciated.
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> *Error! Filename not specified.*
>
>
>
> My first guess would be a networking problem. If you run ifconfig
> repeatedly do you notice the number of errors increasing? It would be goo=
d
> to look at both the database server and the web server. Also, until you
> figure the issue out you should be able to mitigate it by setting the
> connect timeout to a more aggressive value.
>
>
> --
> Rob Wultsch
> wultsch@gmail.com
>
>
>
>
> --
> Rob Wultsch
> wultsch@gmail.com
>



--=20
Rob Wultsch
wultsch@gmail.com

--001636164ab56e9756048a63cbd3
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

I do not know that part of the mysql source code well, but I am very sure y=
ou will take the dns hit even if all of your grants are ip based.

I =
suggest you put put that setting into your cnf and bounce the instance.



You will also never run into issues with max connect error if you set s=
kip name resolve.

It might be worthwhile to start watching a continu=
ous ping from the webserver to the db server. Are you losing any packets? r>